Daily Account Activity File Drop By Partner Report

The purpose of this section is to explain the Daily Account Activity report. This report lets you see all the money movement for a single given master account.

This report can be used to reconcile between what you requested from COS and what COS actually processed.

Glossary

Term	Description
CRB	Cross River Bank
Partner	CRB’s immediate customer, i.e. you

Column	Description
Id	This is internal to CRB and can be disregarded.
TransactionId	Unique identification number for the related core transaction.
TraceNumber	A unique number assigned to the transaction by COS.
Status	Transaction status.
TransactionType	Core transaction type, which can be either Debit or Credit.
ActivityType	Indicates whether the activity is internal (between two sub accounts under the same master account) or external (between two master accounts).
Source	Activity type, which includes: Transaction: Activity from transactions will first soft post, remaining as status pending for the day, and later hard post during the nightly settlement process. Once hard posted a sequence number and running balance are assigned. MemoPosts: Activity from memo posts are a temporary debit or credit on the account. Commonly they will be removed and then posted as a transaction.
MasterAccountNumber	Master account affected by the transaction.
SubAccountNumber	Sub ledger account affected by the transaction.
TransactionCode	Indicates transaction types as follows: Incoming ACH Outgoing ACH Account Transfer Fee Fee Refund Deposit Withdrawal Interest Misc Credit Misc Debit Incoming Wire Outgoing Wire Check Cash Reversal Adjustment Sale Card Auth Payment Refund ATM Transaction Zelle Debit Zelle Credit RTP Debit RTP Credit
Description	Transaction description.
Rail	Rail type (i.e. ACH, Wires, etc.)
RailId	Rail ID, which is a combination of the transaction code and the payment ID.
Amount	Transaction amount.
Balance	Balance resulting from the transaction.
SequenceNumber	Sequence number of the payment in the batch. The sequence number is inserted once the transaction has been posted.
ProductId	Product identifier for the account involved in the transaction.
PartnerId	Unique identification number for the partner resource.
ExecutedAt	Date and time the transaction was executed.
PostingDate	Transaction posting date.
PostedAt	Date and time the transaction was posted, specifically at end of day settlement.
CreatedAt	Date and time the transaction was created.
LastModifiedAt	Date and time of the last change to the resource record.
Flags	An additional identifier added to certain transaction scenarios.

Daily Account Balance By Partner Report

The purpose of this section is to explain the Daily Account Balance By Partner report. This report lets you see the daily account balances for all the master accounts of a single given partner.

This report can be used to reconcile between what you requested from COS and what COS actually processed.

Column	Description
Account Number	Account Number.
Account_Title	Title of the account.
Account_Type	Account type.
Date_Account_Opened	Date on which the account was opened.
Available_Balance	Total available balance of the account.
Current_Balance	Total current balance of the account.